﻿using System;
using System.Data;
using System.Collections.Generic;

using Com.Framework.Data;
using Com.Library.DB;

namespace Com.Library.DB.User
{
	internal class UserGetList : DBDataReader<UserEntity, OutputEntity>
	{
		public UserGetList()
			: base(new ConnectionString(), "TSP_User_GetList")
		{
		}

		protected override void ParameterInitialize()
		{
			AddParameter("IsRemoved", SqlDbType.TinyInt, 1, SqlDataInOut.Input);
			AddParameter("IsLocalUser_search", SqlDbType.Char, 1, SqlDataInOut.Input);
			AddParameter("strUserID_search", SqlDbType.VarChar, 50, SqlDataInOut.Input);
			AddParameter("strUserName_search", SqlDbType.NVarChar, 50, SqlDataInOut.Input);
			AddParameter("n1GroupType_search", SqlDbType.TinyInt, 1, SqlDataInOut.Input);
			AddParameter("dtJoinDate_start_search", SqlDbType.DateTime, 8, SqlDataInOut.Input);
			AddParameter("dtJoinDate_end_search", SqlDbType.DateTime, 8, SqlDataInOut.Input);
			AddParameter("PageNo", SqlDbType.Int, 4, SqlDataInOut.Input);
			AddParameter("PageSize", SqlDbType.TinyInt, 1, SqlDataInOut.Input);
			AddParameter("CntRow", SqlDbType.Int, 4, SqlDataInOut.Output);
			AddParameter("CntTotal", SqlDbType.Int, 4, SqlDataInOut.Output);
		}
	}
}